#  Copyright (c) 2010
#  The Regents of the University of Michigan
#  All Rights Reserved

#  Permission is granted to use, copy, create derivative works, and
#  redistribute this software and such derivative works for any purpose,
#  so long as the name of the University of Michigan is not used in
#  any advertising or publicity pertaining to the use or distribution
#  of this software without specific, written prior authorization. If
#  the above copyright notice or any other identification of the
#  University of Michigan is included in any copy of any portion of
#  this software, then the disclaimer below must also be included.

#  This software is provided as is, without representation or warranty
#  of any kind either express or implied, including without limitation
#  the implied warranties of merchantability, fitness for a particular
#  purpose, or noninfringement.  The Regents of the University of
#  Michigan shall not be liable for any damages, including special,
#  indirect, incidental, or consequential damages, with respect to any
#  claim arising out of or in connection with the use of the software,
#  even if it has been or is hereafter advised of the possibility of
#  such damages.
import matplotlib
matplotlib.use('cairo.png')

import psycopg2

from util import *

def get_total_ips(dirs):
  query = '''SELECT * FROM
             (SELECT peer FROM peer_lists_%s
             GROUP BY peer)s'''
    
  big_query = ' UNION '.join(query % get_db_suffix(dir) for dir in dirs)
  overall_query = 'SELECT COUNT(*) FROM %s' % big_query
  conn = get_db_conn()
  c = conn.cursor()
  c.execute(overall_query)
  return c.fetchone()[0]

def dump_ip_stats(dirs):
  conn = get_db_conn()
  c = conn.cursor()
  for dir in dirs:
    suffix = get_db_suffix(dir)
    c.execute(
